import pandas as pd
import json

# 读取Excel文件
df = pd.read_excel('data/委办单位.xls',usecols=[1,2])

danwei2id = {}
for item in df.values.tolist():
    danwei2id[item[0]] = item[1]

    print(item)


with open("data/danwei2id.json","w") as f:
     json.dump(danwei2id,f,ensure_ascii=False)
     print("加载入文件完成...")